package com.zb.smbmsc.dao.user;

import com.zb.smbmsc.pojo.Role;
import com.zb.smbmsc.pojo.User;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface UserDao {

    User getUser(Connection connection, String userCode) throws SQLException;

    int updatePwd(Connection connection, int userId, String userPassword) throws SQLException;

    int selectUserCount(Connection connection, String userName, String userRole) throws SQLException;

    List<User> selectUserList(Connection connection,  String userName, String userRole, int currentPageNo, int pageSize) throws SQLException;

    List<Role> getRoleList(Connection connection) throws SQLException;
}
